package br.com.universidade.dao.sql;

public class SQLMateria {
	public static final String CMD_INSERT_MATERIA = "insert into materia(nome,descricao,professor_id) values (?,?,?)";
	public static final String CMD_DELETE_MATERIA = "delete from materia where idMateria=?";
	public static final String CMD_GET_BY_ID_MATERIA= "select * from materia where idMateria=?";
	public static final String CMD_FIND_ALL_MATERIA = "select * from materia";
	public static final String CMD_UPDATE_MATERIA = "update materia set nome = ?,descricao=?,professor_id=? WHERE idMateria= ?";
	public static final String CMD_DELETE_ALUNOSMATRICULADOS="delete from alunomatriculado where idMateria=?";
	
	 
}
